2016-06-22 - 27492 - Enhancement - OSA180-Deleted Contracts ECC-BW mismatch #SalesDistribution
SPECIFICATIONS
27492- OSA180-deleted contracts ecc/bw mismatch
Purpose
Need to update the sales rep and customer service representative in the report along with seeing why the deleted contracts are still being displayed in bw sources.
Admin Info
Purpose
|
Need to update the sales rep and customer service representative in the report along with seeing why the deleted contracts are still being displayed in bw sources.
|
Requested By
|
Nicole Rybarczyk
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
06/22/2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZAFSDDS1,
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
06
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
20
|
4
|
Unit test in DEV
|
05
|
5
|
Unit test in QUA
|
05
|
6
|
Other activity
|
20
|
|
TOTAL
|
60
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
1. Need to analyze why the deleted contracts are still being displayed in report and fix the issue not to display deleted contracts in report.
2. Need to update Sales rep and Customer Service in OSA180 report.
In Scope:
Contract Source.
Out of Scope:
Other Sources.
Solution Summary
1) Deleted Contracts:
a. Need to analyse why the deleted contracts are being displayed in the report.
b. For immediate solution, need to develop a report on CDHDR & CDPOS tables & fetch deleted contract orders.
c. Need to cross check manually if all the contract order line items are true.
d. Need to do selective deletion from Sales Order DSO in BW, for identified deleted contract order line items.
2) Update Sales rep & Customer Service representative in Report:
a. Need to fetch customer service representative into BW.
b. As the customer representative is assigned at customer level in NEP & due to inconsistency in data, its currently on hold.
Solution Details
1) Deleted Contracts:
a. Analysed why the deleted contracts are being displayed in the report.
b. Developed a report on CDHDR & CDPOS tables & fetched deleted contract orders.
c. Cross checked manually if all the contract order line items are true.
d. Selective deletion from Sales Order DSO in BW was done, for identified deleted contract order line items.
2) Update Sales rep & Customer Service representative in Report:
a. Fetched customer service representative into BW.
b. As the customer representative is assigned at customer level in NEP & due to inconsistency in data, its currently on hold.
Issues
As the contract orders which are deleted and recreated with the same document number and item number, need to check manually each record before doing selective deletion in BW.